﻿using System.Collections.Generic;
using System.Data.Common;
using System.Data;
using MyFloridaHouse.DataAccess.Extensions;
using MyFloridaHouse.libSvDTO;
using System.Data.SqlClient;
using MyFloridaHouse.LibDTO;

namespace MyFloridaHouse.DataAccess
{
	/// <summary>
	/// Data Access Layer to SQL Census Data Store
	/// </summary>
    //public partial class DAL_CensusData
    //{

    //    //TODO: Remove part of GetDistrictPlan that reads configKey , then can delete this function

    //    /// <summary>
    //    /// Gets the current config key.
    //    /// </summary>
    //    /// <param name="iFileName">Name of the i file.</param>
    //    /// <returns>string</returns>
    //    /// <remarks>SPROC: usp_GetCurrentConfigKey</remarks>
    //    public string GetCurrentConfigKey(string iFileName)
    //    {
    //        string currentKey="";

    //        ////string storedProcedureName = "usp_GetCurrentConfigKey";
    //        //string storedProcedureName = "usp_tl10GetCurrentConfigKey10";

    //        //using (SqlConnection db = Connect())
    //        //{
    //        //    SqlCommand StoredProcedureCommand = new SqlCommand(storedProcedureName, db);
    //        //    StoredProcedureCommand.CommandType = CommandType.StoredProcedure;
    //        //    SqlParameter dataPartIDParm = StoredProcedureCommand.Parameters.AddWithValue("fileName", iFileName);
    //        //    dataPartIDParm.Direction = ParameterDirection.Input;

    //        //    db.Open();
    //        //    using (SqlDataReader rdr = StoredProcedureCommand.ExecuteReader())
    //        //    {
    //        //        while (rdr.Read())
    //        //        {
    //        //            currentKey = rdr.GetString(0);
    //        //        }
    //        //    }
    //        //}
    //        return currentKey;
    //    }
    //}
}
